package com.jinzhi.jzweb.dao;

import com.jinzhi.common.base.BaseDao;
import com.jinzhi.jzweb.domain.ExaminationAnswerSheetDO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 
 * <pre>
 * 考试答卷
 * </pre>
 * <small> 2020-02-24 21:00:12 | lance</small>
 */
public interface ExaminationAnswerSheetDao extends BaseDao<ExaminationAnswerSheetDO> {


	@Select("SELECT jeas.id ,jeas.epaper_id as epaperId , jeas.stu_sign_id as stuSignId , jeas.answer_list as answerList FROM jz_stu_sign_up as stu " +
			"left join jz_organization_news as jon on stu.org_id = jon.id " +
			"left join jz_examination_answer_sheet as jeas on stu.id = jeas.stu_sign_id " +
			"where jon.id = #{orgId} and jeas.id is not NULL ")
	List<ExaminationAnswerSheetDO> findList (Long orgId);

}
